Overview

Dataset info

Number of variables54
Number of observations7043
Missing cells10348 (2.7%)
Duplicate rows0 (0.0%)
Total size in memory8.7 MiB
Average record size in memory1.3 KiB

Variables types

BOOL20
NUM20
CAT14

Reproduction info

Date of analysis2020-05-07 21:42:41.328454
Versionpandas-profiling v2.4.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download Configurationconfig.yaml

Warnings

Avg_Monthly_GB_Download has 1526 (21.7%) zeros Zeros
Avg_Monthly_Long_Distance_Charges has 682 (9.7%) zeros Zeros
Churn_Category has 5174 (73.5%) missing values Missing
Churn_Reason has 5174 (73.5%) missing values Missing
City has a high cardinality: 1106 distinct values Warning
Count has constant value "1" Rejected
Country has constant value "United States" Rejected
Customer_ID has a high cardinality: 7043 distinct values Warning
Lat_Long has a high cardinality: 1679 distinct values Warning
Number_of_Dependents has 5416 (76.9%) zeros Zeros
Number_of_Referrals has 3821 (54.3%) zeros Zeros
Quarter has constant value "Q3" Rejected
State has constant value "California" Rejected
Total_Extra_Data_Charges has 6315 (89.7%) zeros Zeros
Total_Long_Distance_Charges has 682 (9.7%) zeros Zeros
Total_Refunds has 6518 (92.5%) zeros Zeros
Latitude is highly correlated with IDHigh Correlation
ID is highly correlated with Latitude and 1 other fieldsHigh Correlation
Total_Revenue is highly correlated with Total_ChargesHigh Correlation
Total_Charges is highly correlated with Total_RevenueHigh Correlation
Zip_Code is highly correlated with IDHigh Correlation
Quarter is highly correlated with Country and 1 other fieldsHigh Correlation
Country is highly correlated with Quarter and 1 other fieldsHigh Correlation
State is highly correlated with Country and 1 other fieldsHigh Correlation

Variables

Age
Real number (ℝ≥0)

Distinct count62
Unique (%)0.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean46.50972597
Minimum19
Maximum80
Zeros0
Zeros (%)0.0%
Memory size110.0 KiB
Mini histogram

Quantile statistics

Minimum19
5-th percentile21
Q132
median46
Q360
95-th percentile75
Maximum80
Range61
Interquartile range (IQR)28

Descriptive statistics

Standard deviation16.75035166
Coefficient of variation (CV)0.3601472876
Kurtosis-1.00284948
Mean46.50972597
Median Absolute Deviation (MAD)14.23865567
Skewness0.1621864487
Sum327568
Variance280.5742806
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[19. 19.5 64.5 79.5 80. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
42 156 2.2%
 
47 153 2.2%
 
40 150 2.1%
 
44 148 2.1%
 
23 146 2.1%
 
56 144 2.0%
 
62 143 2.0%
 
35 142 2.0%
 
21 140 2.0%
 
33 139 2.0%
 
Other values (52) 5582 79.3%
 
ValueCountFrequency (%) 
19 127 1.8%
 
20 127 1.8%
 
21 140 2.0%
 
22 130 1.8%
 
23 146 2.1%
 
ValueCountFrequency (%) 
80 66 0.9%
 
79 76 1.1%
 
78 63 0.9%
 
77 72 1.0%
 
76 69 1.0%
 

Avg_Monthly_GB_Download
Real number (ℝ≥0)

ZEROS
Distinct count50
Unique (%)0.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20.51540537
Minimum0
Maximum85
Zeros1526
Zeros (%)21.7%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q13
median17
Q327
95-th percentile69
Maximum85
Range85
Interquartile range (IQR)24

Descriptive statistics

Standard deviation20.41894039
Coefficient of variation (CV)0.995297925
Kurtosis0.8815023103
Mean20.51540537
Median Absolute Deviation (MAD)15.49305313
Skewness1.216583903
Sum144490
Variance416.9331267
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 1. 2.5 10.5 18.5 ... 64. 72. 74. 83.5 85. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 1526 21.7%
 
19 220 3.1%
 
27 199 2.8%
 
30 193 2.7%
 
59 192 2.7%
 
26 191 2.7%
 
23 179 2.5%
 
22 172 2.4%
 
21 171 2.4%
 
13 164 2.3%
 
Other values (40) 3836 54.5%
 
ValueCountFrequency (%) 
0 1526 21.7%
 
2 116 1.6%
 
3 130 1.8%
 
4 129 1.8%
 
5 114 1.6%
 
ValueCountFrequency (%) 
85 48 0.7%
 
82 43 0.6%
 
76 58 0.8%
 
75 15 0.2%
 
73 81 1.2%
 

Avg_Monthly_Long_Distance_Charges
Real number (ℝ≥0)

ZEROS
Distinct count3584
Unique (%)50.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.95895357
Minimum0
Maximum49.99
Zeros682
Zeros (%)9.7%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q19.21
median22.89
Q336.395
95-th percentile47.34
Maximum49.99
Range49.99
Interquartile range (IQR)27.185

Descriptive statistics

Standard deviation15.44811335
Coefficient of variation (CV)0.6728579026
Kurtosis-1.25465441
Mean22.95895357
Median Absolute Deviation (MAD)13.47216416
Skewness0.04917589934
Sum161699.91
Variance238.6442059
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.505 1.015 49.99 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 682 9.7%
 
18.26 7 0.1%
 
34.49 6 0.1%
 
30.07 6 0.1%
 
18.42 6 0.1%
 
10.11 6 0.1%
 
22.83 6 0.1%
 
42.55 6 0.1%
 
45.92 6 0.1%
 
22.56 6 0.1%
 
Other values (3574) 6306 89.5%
 
ValueCountFrequency (%) 
0 682 9.7%
 
1.01 1 < 0.1%
 
1.02 3 < 0.1%
 
1.03 1 < 0.1%
 
1.05 1 < 0.1%
 
ValueCountFrequency (%) 
49.99 1 < 0.1%
 
49.98 3 < 0.1%
 
49.96 2 < 0.1%
 
49.95 2 < 0.1%
 
49.94 1 < 0.1%
 

Churn_Category
Categorical

MISSING
Distinct count6
Unique (%)0.1%
Missing5174
Missing (%)73.5%
Memory size338.5 KiB
Competitor
841
Attitude
314
Dissatisfaction
303
Price
211
Other
200
ValueCountFrequency (%) 
Competitor 841 11.9%
 
Attitude 314 4.5%
 
Dissatisfaction 303 4.3%
 
Price 211 3.0%
 
Other 200 2.8%
 
(Missing) 5174 73.5%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length15
Mean length4.691750674
Min length3
Scatter
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size82.5 KiB
No
5174
Yes
1869
ValueCountFrequency (%) 
No 5174 73.5%
 
Yes 1869 26.5%
 

Churn_Reason
Categorical

MISSING
Distinct count21
Unique (%)0.3%
Missing5174
Missing (%)73.5%
Memory size338.5 KiB
Competitor had better devices
313
Competitor made better offer
311
Attitude of support person
220
Don't know
 
130
Competitor offered more data
 
117
Other values (15)
778
ValueCountFrequency (%) 
Competitor had better devices 313 4.4%
 
Competitor made better offer 311 4.4%
 
Attitude of support person 220 3.1%
 
Don't know 130 1.8%
 
Competitor offered more data 117 1.7%
 
Competitor offered higher download speeds 100 1.4%
 
Attitude of service provider 94 1.3%
 
Price too high 78 1.1%
 
Product dissatisfaction 77 1.1%
 
Network reliability 72 1.0%
 
Other values (10) 357 5.1%
 
(Missing) 5174 73.5%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length41
Mean length8.906289933
Min length3
Scatter

Churn_Score
Real number (ℝ≥0)

Distinct count81
Unique (%)1.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean58.50504047
Minimum5
Maximum96
Zeros0
Zeros (%)0.0%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum5
5-th percentile24
Q140
median61
Q375.5
95-th percentile91
Maximum96
Range91
Interquartile range (IQR)35.5

Descriptive statistics

Standard deviation21.17003078
Coefficient of variation (CV)0.3618496904
Kurtosis-1.085289995
Mean58.50504047
Median Absolute Deviation (MAD)18.25163382
Skewness-0.1568522156
Sum412051
Variance448.1702032
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 5. 14.5 20.5 64.5 80.5 89.5 90.5 91.5 95.5 96. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
91 202 2.9%
 
80 150 2.1%
 
71 148 2.1%
 
77 145 2.1%
 
67 142 2.0%
 
76 140 2.0%
 
68 140 2.0%
 
90 139 2.0%
 
70 138 2.0%
 
69 138 2.0%
 
Other values (71) 5561 79.0%
 
ValueCountFrequency (%) 
5 1 < 0.1%
 
7 2 < 0.1%
 
8 2 < 0.1%
 
9 3 < 0.1%
 
20 83 1.2%
 
ValueCountFrequency (%) 
96 49 0.7%
 
95 46 0.7%
 
94 46 0.7%
 
93 50 0.7%
 
92 51 0.7%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size366.0 KiB
0
5174
1
1869
ValueCountFrequency (%) 
0 5174 73.5%
 
1 1869 26.5%
 

City
Categorical

HIGH CARDINALITY
Distinct count1106
Unique (%)15.7%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
Los Angeles
 
293
San Diego
 
285
San Jose
 
112
Sacramento
 
108
San Francisco
 
104
Other values (1101)
6141
ValueCountFrequency (%) 
Los Angeles 293 4.2%
 
San Diego 285 4.0%
 
San Jose 112 1.6%
 
Sacramento 108 1.5%
 
San Francisco 104 1.5%
 
Fresno 61 0.9%
 
Long Beach 60 0.9%
 
Oakland 52 0.7%
 
Escondido 51 0.7%
 
Stockton 44 0.6%
 
Other values (1096) 5873 83.4%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length22
Mean length9.203464433
Min length3
Scatter

CLTV
Real number (ℝ≥0)

Distinct count3438
Unique (%)48.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4400.295755
Minimum2003
Maximum6500
Zeros0
Zeros (%)0.0%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum2003
5-th percentile2296
Q13469
median4527
Q35380.5
95-th percentile6087
Maximum6500
Range4497
Interquartile range (IQR)1911.5

Descriptive statistics

Standard deviation1183.057152
Coefficient of variation (CV)0.2688585536
Kurtosis-0.934032483
Mean4400.295755
Median Absolute Deviation (MAD)994.7244369
Skewness-0.3116021004
Sum30991283
Variance1399624.225
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[2003. 3999.5 5996.5 6500. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
5546 8 0.1%
 
4741 7 0.1%
 
5137 7 0.1%
 
2269 7 0.1%
 
4115 7 0.1%
 
4745 7 0.1%
 
5461 7 0.1%
 
4369 7 0.1%
 
5092 7 0.1%
 
5527 7 0.1%
 
Other values (3428) 6972 99.0%
 
ValueCountFrequency (%) 
2003 3 < 0.1%
 
2004 3 < 0.1%
 
2006 1 < 0.1%
 
2007 4 0.1%
 
2008 1 < 0.1%
 
ValueCountFrequency (%) 
6500 1 < 0.1%
 
6499 2 < 0.1%
 
6495 1 < 0.1%
 
6494 2 < 0.1%
 
6492 3 < 0.1%
 

Contract
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
Month-to-Month
3610
Two Year
1883
One Year
1550
ValueCountFrequency (%) 
Month-to-Month 3610 51.3%
 
Two Year 1883 26.7%
 
One Year 1550 22.0%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length14
Mean length11.07539401
Min length8
Scatter

Count
Boolean

CONST
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size366.0 KiB
1
7043
ValueCountFrequency (%) 
1 7043 100.0%
 

Country
Categorical

CONST
HIGH CORRELATION
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
United States
7043
ValueCountFrequency (%) 
United States 7043 100.0%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length13
Mean length13
Min length13
Scatter

Customer_ID
Categorical

UNIQUE
HIGH CARDINALITY
Distinct count7043
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
9518-XXBXE
 
1
5075-JSDKI
 
1
6680-NENYN
 
1
6496-JDSSB
 
1
2465-BLLEU
 
1
Other values (7038)
7038
ValueCountFrequency (%) 
9518-XXBXE 1 < 0.1%
 
5075-JSDKI 1 < 0.1%
 
6680-NENYN 1 < 0.1%
 
6496-JDSSB 1 < 0.1%
 
2465-BLLEU 1 < 0.1%
 
9964-WBQDJ 1 < 0.1%
 
9972-EWRJS 1 < 0.1%
 
7672-VFMXZ 1 < 0.1%
 
2369-FEVNO 1 < 0.1%
 
6685-XSHHU 1 < 0.1%
 
Other values (7033) 7033 99.9%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length10
Mean length10
Min length10
Scatter

Customer_Status
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
Stayed
4720
Churned
1869
Joined
 
454
ValueCountFrequency (%) 
Stayed 4720 67.0%
 
Churned 1869 26.5%
 
Joined 454 6.4%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length7
Mean length6.265369871
Min length6
Scatter

Dependents
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
5416
Yes
1627
ValueCountFrequency (%) 
No 5416 76.9%
 
Yes 1627 23.1%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
4621
Yes
2422
ValueCountFrequency (%) 
No 4621 65.6%
 
Yes 2422 34.4%
 

Gender
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
Male
3555
Female
3488
ValueCountFrequency (%) 
Male 3555 50.5%
 
Female 3488 49.5%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length6
Mean length4.990487008
Min length4
Scatter

ID
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count1626
Unique (%)23.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean784.8006531
Minimum1
Maximum1670
Zeros0
Zeros (%)0.0%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum1
5-th percentile73.1
Q1353
median759
Q31208
95-th percentile1574.9
Maximum1670
Range1669
Interquartile range (IQR)855

Descriptive statistics

Standard deviation489.0440495
Coefficient of variation (CV)0.6231442948
Kurtosis-1.24297351
Mean784.8006531
Median Absolute Deviation (MAD)427.8197241
Skewness0.1384875794
Sum5527351
Variance239164.0824
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[1.000e+00 3.265e+02 3.285e+02 3.605e+02 3.615e+02 ... 3.785e+02 3.805e+02 5.315e+02 5.325e+02 1.670e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
328 43 0.6%
 
327 38 0.5%
 
373 36 0.5%
 
368 34 0.5%
 
376 32 0.5%
 
532 30 0.4%
 
361 27 0.4%
 
380 22 0.3%
 
372 20 0.3%
 
379 16 0.2%
 
Other values (1616) 6745 95.8%
 
ValueCountFrequency (%) 
1 4 0.1%
 
2 4 0.1%
 
3 5 0.1%
 
4 5 0.1%
 
5 4 0.1%
 
ValueCountFrequency (%) 
1670 2 < 0.1%
 
1669 4 0.1%
 
1668 4 0.1%
 
1667 3 < 0.1%
 
1666 4 0.1%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
Yes
5517
No
1526
ValueCountFrequency (%) 
Yes 5517 78.3%
 
No 1526 21.7%
 

Internet_Type
Categorical

Distinct count4
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
Fiber Optic
3035
DSL
1652
None
1526
Cable
830
ValueCountFrequency (%) 
Fiber Optic 3035 43.1%
 
DSL 1652 23.5%
 
None 1526 21.7%
 
Cable 830 11.8%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length11
Mean length6.899758626
Min length3
Scatter

Lat_Long
Categorical

HIGH CARDINALITY
Distinct count1679
Unique (%)23.8%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
33.362575, -117.299644
 
43
33.141265, -116.967221
 
38
32.825086, -117.199424
 
34
32.886925, -117.152162
 
32
33.507255, -117.029473
 
30
Other values (1674)
6866
ValueCountFrequency (%) 
33.362575, -117.299644 43 0.6%
 
33.141265, -116.967221 38 0.5%
 
32.825086, -117.199424 34 0.5%
 
32.886925, -117.152162 32 0.5%
 
33.507255, -117.029473 30 0.4%
 
32.957195, -117.202542 22 0.3%
 
32.898613, -117.202937 20 0.3%
 
32.961064, -117.134917 16 0.2%
 
34.102119, -117.815532 8 0.1%
 
33.840524, -118.148403 7 0.1%
 
Other values (1669) 6793 96.5%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length22
Mean length21.78418288
Min length18
Scatter

Latitude
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count1626
Unique (%)23.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.19745482
Minimum32.555828
Maximum41.962127
Zeros0
Zeros (%)0.0%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum32.555828
5-th percentile32.886925
Q133.990646
median36.205465
Q338.161321
95-th percentile40.4974252
Maximum41.962127
Range9.406299
Interquartile range (IQR)4.170675

Descriptive statistics

Standard deviation2.468928682
Coefficient of variation (CV)0.06820724534
Kurtosis-1.160506077
Mean36.19745482
Median Absolute Deviation (MAD)2.233057555
Skewness0.3148042686
Sum254938.6743
Variance6.095608835
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[32.555828 32.671095 32.7416755 32.7418555 32.7865005 ... 38.731413 38.736237 39.301805 40.9570115 41.962127 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
33.362575 43 0.6%
 
33.141265 38 0.5%
 
32.85723 36 0.5%
 
32.825086 34 0.5%
 
32.886925 32 0.5%
 
33.507255 30 0.4%
 
32.787836 27 0.4%
 
32.957195 22 0.3%
 
32.898613 20 0.3%
 
32.961064 16 0.2%
 
Other values (1616) 6745 95.8%
 
ValueCountFrequency (%) 
32.555828 5 0.1%
 
32.578103 4 0.1%
 
32.579134 4 0.1%
 
32.587557 5 0.1%
 
32.605012 4 0.1%
 
ValueCountFrequency (%) 
41.962127 4 0.1%
 
41.950683 4 0.1%
 
41.949216 4 0.1%
 
41.932207 3 < 0.1%
 
41.924174 3 < 0.1%
 

Longitude
Real number (ℝ)

Distinct count1625
Unique (%)23.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-119.7566837
Minimum-124.301372
Maximum-114.192901
Zeros0
Zeros (%)0.0%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum-124.301372
5-th percentile-122.9755
Q1-121.78809
median-119.595293
Q3-117.969795
95-th percentile-116.873258
Maximum-114.192901
Range10.108471
Interquartile range (IQR)3.818295

Descriptive statistics

Standard deviation2.154425092
Coefficient of variation (CV)-0.01799001965
Kurtosis-1.191290554
Mean-119.7566837
Median Absolute Deviation (MAD)1.932931396
Skewness-0.09193163502
Sum-843446.3231
Variance4.641547478
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[-124.301372 -123.8626625 -123.3672595 -123.07077 -122.5967105 ... -116.5935305 -116.092795 -115.676134 -115.464355 -114.192901 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-117.299644 43 0.6%
 
-116.967221 38 0.5%
 
-117.209774 36 0.5%
 
-117.199424 34 0.5%
 
-117.152162 32 0.5%
 
-117.029473 30 0.4%
 
-117.232376 27 0.4%
 
-117.202542 22 0.3%
 
-117.202937 20 0.3%
 
-117.134917 16 0.2%
 
Other values (1615) 6745 95.8%
 
ValueCountFrequency (%) 
-124.301372 4 0.1%
 
-124.240051 4 0.1%
 
-124.217378 4 0.1%
 
-124.210902 4 0.1%
 
-124.189977 4 0.1%
 
ValueCountFrequency (%) 
-114.192901 4 0.1%
 
-114.36514 5 0.1%
 
-114.702256 4 0.1%
 
-114.71612 4 0.1%
 
-114.758334 5 0.1%
 

Married
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
3641
Yes
3402
ValueCountFrequency (%) 
No 3641 51.7%
 
Yes 3402 48.3%
 

Monthly_Charge
Real number (ℝ≥0)

Distinct count1585
Unique (%)22.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64.76169246
Minimum18.25
Maximum118.75
Zeros0
Zeros (%)0.0%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum18.25
5-th percentile19.65
Q135.5
median70.35
Q389.85
95-th percentile107.4
Maximum118.75
Range100.5
Interquartile range (IQR)54.35

Descriptive statistics

Standard deviation30.0900471
Coefficient of variation (CV)0.4646272504
Kurtosis-1.257259695
Mean64.76169246
Median Absolute Deviation (MAD)26.22210151
Skewness-0.2205244339
Sum456116.6
Variance905.4109343
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 18.25 18.775 19.175 19.525 20.275 ... 103.625 106.175 111.325 116.675 118.75 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
20.05 61 0.9%
 
19.85 45 0.6%
 
19.9 44 0.6%
 
19.95 44 0.6%
 
19.65 43 0.6%
 
20 43 0.6%
 
19.7 43 0.6%
 
20.15 40 0.6%
 
19.55 40 0.6%
 
20.25 39 0.6%
 
Other values (1575) 6601 93.7%
 
ValueCountFrequency (%) 
18.25 1 < 0.1%
 
18.4 1 < 0.1%
 
18.55 1 < 0.1%
 
18.7 2 < 0.1%
 
18.75 1 < 0.1%
 
ValueCountFrequency (%) 
118.75 1 < 0.1%
 
118.65 1 < 0.1%
 
118.6 2 < 0.1%
 
118.35 1 < 0.1%
 
118.2 1 < 0.1%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
4072
Yes
2971
ValueCountFrequency (%) 
No 4072 57.8%
 
Yes 2971 42.2%
 

Number_of_Dependents
Real number (ℝ≥0)

ZEROS
Distinct count10
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.4686923186
Minimum0
Maximum9
Zeros5416
Zeros (%)76.9%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile3
Maximum9
Range9
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.9628019509
Coefficient of variation (CV)2.054230276
Kurtosis4.446357934
Mean0.4686923186
Median Absolute Deviation (MAD)0.7208398687
Skewness2.109931981
Sum3301
Variance0.9269875967
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.5 3.5 5.5 9. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 5416 76.9%
 
1 553 7.9%
 
2 531 7.5%
 
3 517 7.3%
 
5 10 0.1%
 
4 9 0.1%
 
6 3 < 0.1%
 
7 2 < 0.1%
 
9 1 < 0.1%
 
8 1 < 0.1%
 
ValueCountFrequency (%) 
0 5416 76.9%
 
1 553 7.9%
 
2 531 7.5%
 
3 517 7.3%
 
4 9 0.1%
 
ValueCountFrequency (%) 
9 1 < 0.1%
 
8 1 < 0.1%
 
7 2 < 0.1%
 
6 3 < 0.1%
 
5 10 0.1%
 

Number_of_Referrals
Real number (ℝ≥0)

ZEROS
Distinct count12
Unique (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.951867102
Minimum0
Maximum11
Zeros3821
Zeros (%)54.3%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q33
95-th percentile9
Maximum11
Range11
Interquartile range (IQR)3

Descriptive statistics

Standard deviation3.0011993
Coefficient of variation (CV)1.537604326
Kurtosis0.7219639341
Mean1.951867102
Median Absolute Deviation (MAD)2.411418961
Skewness1.446059625
Sum13747
Variance9.007197238
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 10.5 11. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 3821 54.3%
 
1 1086 15.4%
 
5 264 3.7%
 
3 255 3.6%
 
7 248 3.5%
 
9 238 3.4%
 
2 236 3.4%
 
4 236 3.4%
 
10 223 3.2%
 
6 221 3.1%
 
Other values (2) 215 3.1%
 
ValueCountFrequency (%) 
0 3821 54.3%
 
1 1086 15.4%
 
2 236 3.4%
 
3 255 3.6%
 
4 236 3.4%
 
ValueCountFrequency (%) 
11 2 < 0.1%
 
10 223 3.2%
 
9 238 3.4%
 
8 213 3.0%
 
7 248 3.5%
 

Offer
Categorical

Distinct count6
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
None
3877
Offer B
824
Offer E
805
Offer D
 
602
Offer A
 
520
ValueCountFrequency (%) 
None 3877 55.0%
 
Offer B 824 11.7%
 
Offer E 805 11.4%
 
Offer D 602 8.5%
 
Offer A 520 7.4%
 
Offer C 415 5.9%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length7
Mean length5.348573051
Min length4
Scatter
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
4614
Yes
2429
ValueCountFrequency (%) 
No 4614 65.5%
 
Yes 2429 34.5%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
5024
Yes
2019
ValueCountFrequency (%) 
No 5024 71.3%
 
Yes 2019 28.7%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
Yes
4171
No
2872
ValueCountFrequency (%) 
Yes 4171 59.2%
 
No 2872 40.8%
 

Payment_Method
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
Bank Withdrawal
3909
Credit Card
2749
Mailed Check
 
385
ValueCountFrequency (%) 
Bank Withdrawal 3909 55.5%
 
Credit Card 2749 39.0%
 
Mailed Check 385 5.5%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length15
Mean length13.27474088
Min length11
Scatter
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
Yes
6361
No
 
682
ValueCountFrequency (%) 
Yes 6361 90.3%
 
No 682 9.7%
 

Population
Real number (ℝ≥0)

Distinct count1569
Unique (%)22.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22139.60329
Minimum11
Maximum105285
Zeros0
Zeros (%)0.0%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum11
5-th percentile227
Q12344
median17554
Q336125
95-th percentile62065.7
Maximum105285
Range105274
Interquartile range (IQR)33781

Descriptive statistics

Standard deviation21152.39284
Coefficient of variation (CV)0.9554097495
Kurtosis0.3254602142
Mean22139.60329
Median Absolute Deviation (MAD)17624.79706
Skewness0.9128540219
Sum155929226
Variance447423722.7
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[1.10000e+01 7.00000e+01 9.20000e+01 2.61500e+02 2.65500e+02 ... 6.33125e+04 7.41285e+04 7.44365e+04 8.23080e+04 1.05285e+05], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
42239 43 0.6%
 
48690 38 0.5%
 
34902 36 0.5%
 
51213 34 0.5%
 
74232 32 0.5%
 
46171 30 0.4%
 
46086 27 0.4%
 
28201 22 0.3%
 
4258 20 0.3%
 
88 20 0.3%
 
Other values (1559) 6741 95.7%
 
ValueCountFrequency (%) 
11 5 0.1%
 
19 4 0.1%
 
21 9 0.1%
 
23 3 < 0.1%
 
25 4 0.1%
 
ValueCountFrequency (%) 
105285 5 0.1%
 
103214 5 0.1%
 
101215 5 0.1%
 
98239 5 0.1%
 
97318 5 0.1%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
4999
Yes
2044
ValueCountFrequency (%) 
No 4999 71.0%
 
Yes 2044 29.0%
 

Quarter
Categorical

CONST
HIGH CORRELATION
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
Q3
7043
ValueCountFrequency (%) 
Q3 7043 100.0%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length2
Mean length2
Min length2
Scatter
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
3821
Yes
3222
ValueCountFrequency (%) 
No 3821 54.3%
 
Yes 3222 45.7%
 

Satisfaction_Score
Real number (ℝ≥0)

Distinct count5
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.244924038
Minimum1
Maximum5
Zeros0
Zeros (%)0.0%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q13
median3
Q34
95-th percentile5
Maximum5
Range4
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.201657123
Coefficient of variation (CV)0.3703190301
Kurtosis-0.5368532045
Mean3.244924038
Median Absolute Deviation (MAD)0.9562439802
Skewness-0.3674005424
Sum22854
Variance1.44397984
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[1. 2.5 3.5 4.5 5. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
3 2665 37.8%
 
4 1789 25.4%
 
5 1149 16.3%
 
1 922 13.1%
 
2 518 7.4%
 
ValueCountFrequency (%) 
1 922 13.1%
 
2 518 7.4%
 
3 2665 37.8%
 
4 1789 25.4%
 
5 1149 16.3%
 
ValueCountFrequency (%) 
5 1149 16.3%
 
4 1789 25.4%
 
3 2665 37.8%
 
2 518 7.4%
 
1 922 13.1%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
5901
Yes
 
1142
ValueCountFrequency (%) 
No 5901 83.8%
 
Yes 1142 16.2%
 

State
Categorical

CONST
HIGH CORRELATION
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
California
7043
ValueCountFrequency (%) 
California 7043 100.0%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length10
Mean length10
Min length10
Scatter
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
4311
Yes
2732
ValueCountFrequency (%) 
No 4311 61.2%
 
Yes 2732 38.8%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
4555
Yes
2488
ValueCountFrequency (%) 
No 4555 64.7%
 
Yes 2488 35.3%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
4336
Yes
2707
ValueCountFrequency (%) 
No 4336 61.6%
 
Yes 2707 38.4%
 

Tenure_in_Months
Real number (ℝ≥0)

Distinct count72
Unique (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean32.386767
Minimum1
Maximum72
Zeros0
Zeros (%)0.0%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q19
median29
Q355
95-th percentile72
Maximum72
Range71
Interquartile range (IQR)46

Descriptive statistics

Standard deviation24.54206101
Coefficient of variation (CV)0.757780516
Kurtosis-1.387052361
Mean32.386767
Median Absolute Deviation (MAD)21.85859589
Skewness0.2405426141
Sum228100
Variance602.3127587
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 4.5 13.5 26.5 65.5 70.5 71.5 72. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 613 8.7%
 
72 362 5.1%
 
2 238 3.4%
 
3 200 2.8%
 
4 176 2.5%
 
71 170 2.4%
 
5 133 1.9%
 
7 131 1.9%
 
10 127 1.8%
 
8 123 1.7%
 
Other values (62) 4770 67.7%
 
ValueCountFrequency (%) 
1 613 8.7%
 
2 238 3.4%
 
3 200 2.8%
 
4 176 2.5%
 
5 133 1.9%
 
ValueCountFrequency (%) 
72 362 5.1%
 
71 170 2.4%
 
70 119 1.7%
 
69 95 1.3%
 
68 100 1.4%
 

Total_Charges
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count6540
Unique (%)92.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2280.381264
Minimum18.8
Maximum8684.8
Zeros0
Zeros (%)0.0%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum18.8
5-th percentile49.65
Q1400.15
median1394.55
Q33786.6
95-th percentile6921.025
Maximum8684.8
Range8666
Interquartile range (IQR)3386.45

Descriptive statistics

Standard deviation2266.220462
Coefficient of variation (CV)0.9937901605
Kurtosis-0.2276926647
Mean2280.381264
Median Absolute Deviation (MAD)1898.648455
Skewness0.9637910861
Sum16060725.24
Variance5135755.182
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 18.8 19.425 20.525 21.075 24.025 ... 2665.875 5044. 6893.475 8128.45 8684.8 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
20.2 11 0.2%
 
19.75 9 0.1%
 
19.9 8 0.1%
 
19.65 8 0.1%
 
20.05 8 0.1%
 
19.55 7 0.1%
 
45.3 7 0.1%
 
19.45 6 0.1%
 
20.25 6 0.1%
 
20.15 6 0.1%
 
Other values (6530) 6967 98.9%
 
ValueCountFrequency (%) 
18.8 1 < 0.1%
 
18.85 2 < 0.1%
 
18.9 1 < 0.1%
 
19 1 < 0.1%
 
19.05 1 < 0.1%
 
ValueCountFrequency (%) 
8684.8 1 < 0.1%
 
8672.45 1 < 0.1%
 
8670.1 1 < 0.1%
 
8594.4 1 < 0.1%
 
8564.75 1 < 0.1%
 

Total_Extra_Data_Charges
Real number (ℝ≥0)

ZEROS
Distinct count16
Unique (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.860712764
Minimum0
Maximum150
Zeros6315
Zeros (%)89.7%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile60
Maximum150
Range150
Interquartile range (IQR)0

Descriptive statistics

Standard deviation25.104978
Coefficient of variation (CV)3.659237584
Kurtosis16.45887408
Mean6.860712764
Median Absolute Deviation (MAD)12.30310978
Skewness4.091209239
Sum48320
Variance630.2599204
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 5. 15. 45. 145. 150.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 6315 89.7%
 
10 138 2.0%
 
40 62 0.9%
 
30 58 0.8%
 
20 51 0.7%
 
80 47 0.7%
 
100 44 0.6%
 
50 43 0.6%
 
150 42 0.6%
 
130 40 0.6%
 
Other values (6) 203 2.9%
 
ValueCountFrequency (%) 
0 6315 89.7%
 
10 138 2.0%
 
20 51 0.7%
 
30 58 0.8%
 
40 62 0.9%
 
ValueCountFrequency (%) 
150 42 0.6%
 
140 38 0.5%
 
130 40 0.6%
 
120 28 0.4%
 
110 32 0.5%
 

Total_Long_Distance_Charges
Real number (ℝ≥0)

ZEROS
Distinct count6110
Unique (%)86.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean749.0992617
Minimum0
Maximum3564.72
Zeros682
Zeros (%)9.7%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q170.545
median401.44
Q31191.1
95-th percentile2577.877
Maximum3564.72
Range3564.72
Interquartile range (IQR)1120.555

Descriptive statistics

Standard deviation846.6600548
Coefficient of variation (CV)1.130237471
Kurtosis0.644092077
Mean749.0992617
Median Absolute Deviation (MAD)685.4550439
Skewness1.238281984
Sum5275906.1
Variance716833.2484
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.000000e+00 5.650000e-01 3.670000e+00 4.991000e+01 1.510550e+02 ... 1.203040e+03 1.896900e+03 2.433145e+03 2.883805e+03 3.564720e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 682 9.7%
 
22.86 4 0.1%
 
48.96 4 0.1%
 
597.6 3 < 0.1%
 
200.34 3 < 0.1%
 
378 3 < 0.1%
 
198 3 < 0.1%
 
95.64 3 < 0.1%
 
41.1 3 < 0.1%
 
15.28 3 < 0.1%
 
Other values (6100) 6332 89.9%
 
ValueCountFrequency (%) 
0 682 9.7%
 
1.13 1 < 0.1%
 
1.15 1 < 0.1%
 
1.17 1 < 0.1%
 
1.23 1 < 0.1%
 
ValueCountFrequency (%) 
3564.72 1 < 0.1%
 
3564 1 < 0.1%
 
3536.64 1 < 0.1%
 
3515.92 1 < 0.1%
 
3508.82 1 < 0.1%
 

Total_Refunds
Real number (ℝ≥0)

ZEROS
Distinct count500
Unique (%)7.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.962182309
Minimum0
Maximum49.79
Zeros6518
Zeros (%)92.5%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile18.149
Maximum49.79
Range49.79
Interquartile range (IQR)0

Descriptive statistics

Standard deviation7.902614384
Coefficient of variation (CV)4.027461847
Kurtosis18.35065824
Mean1.962182309
Median Absolute Deviation (MAD)3.633345481
Skewness4.328516701
Sum13819.65
Variance62.45131411
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.505 49.79 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 6518 92.5%
 
18.55 2 < 0.1%
 
47.04 2 < 0.1%
 
28.42 2 < 0.1%
 
15.41 2 < 0.1%
 
27.6 2 < 0.1%
 
32.55 2 < 0.1%
 
12.48 2 < 0.1%
 
47.73 2 < 0.1%
 
46.06 2 < 0.1%
 
Other values (490) 507 7.2%
 
ValueCountFrequency (%) 
0 6518 92.5%
 
1.01 1 < 0.1%
 
1.09 1 < 0.1%
 
1.27 1 < 0.1%
 
1.31 2 < 0.1%
 
ValueCountFrequency (%) 
49.79 1 < 0.1%
 
49.76 1 < 0.1%
 
49.57 2 < 0.1%
 
49.53 1 < 0.1%
 
49.51 1 < 0.1%
 

Total_Revenue
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count6996
Unique (%)99.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3034.379056
Minimum21.36
Maximum11979.34
Zeros0
Zeros (%)0.0%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum21.36
5-th percentile78.452
Q1605.61
median2108.64
Q34801.145
95-th percentile8747.041
Maximum11979.34
Range11957.98
Interquartile range (IQR)4195.535

Descriptive statistics

Standard deviation2865.204542
Coefficient of variation (CV)0.9442474025
Kurtosis-0.2034573897
Mean3034.379056
Median Absolute Deviation (MAD)2381.222402
Skewness0.919410268
Sum21371131.69
Variance8209397.065
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 21.36 24.095 25.3 80.9 123.3 ... 4784.79 8735.25 10218.615 11037.435 11979.34 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
66.56 3 < 0.1%
 
24.8 3 < 0.1%
 
68.41 3 < 0.1%
 
2997.45 2 < 0.1%
 
118.98 2 < 0.1%
 
790.7 2 < 0.1%
 
25.25 2 < 0.1%
 
343.68 2 < 0.1%
 
35.25 2 < 0.1%
 
4211.6 2 < 0.1%
 
Other values (6986) 7020 99.7%
 
ValueCountFrequency (%) 
21.36 1 < 0.1%
 
21.4 1 < 0.1%
 
21.61 1 < 0.1%
 
22.08 1 < 0.1%
 
22.12 1 < 0.1%
 
ValueCountFrequency (%) 
11979.34 1 < 0.1%
 
11868.34 1 < 0.1%
 
11795.78 1 < 0.1%
 
11688.9 1 < 0.1%
 
11634.53 1 < 0.1%
 

Under_30
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
No
5642
Yes
1401
ValueCountFrequency (%) 
No 5642 80.1%
 
Yes 1401 19.9%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size338.5 KiB
Yes
4745
No
2298
ValueCountFrequency (%) 
Yes 4745 67.4%
 
No 2298 32.6%
 

Zip_Code
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count1626
Unique (%)23.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean93486.07057
Minimum90001
Maximum96150
Zeros0
Zeros (%)0.0%
Memory size366.0 KiB
Mini histogram

Quantile statistics

Minimum90001
5-th percentile90241.1
Q192101
median93518
Q395329
95-th percentile96020.9
Maximum96150
Range6149
Interquartile range (IQR)3228

Descriptive statistics

Standard deviation1856.767505
Coefficient of variation (CV)0.01986143491
Kurtosis-1.173915431
Mean93486.07057
Median Absolute Deviation (MAD)1621.121476
Skewness-0.2096151191
Sum658422395
Variance3447585.568
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[90001. 90048.5 90056.5 90074. 90205.5 ... 95770.5 95814.5 95842.5 95911. 96150. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
92028 43 0.6%
 
92027 38 0.5%
 
92122 36 0.5%
 
92117 34 0.5%
 
92126 32 0.5%
 
92592 30 0.4%
 
92109 27 0.4%
 
92130 22 0.3%
 
92121 20 0.3%
 
92129 16 0.2%
 
Other values (1616) 6745 95.8%
 
ValueCountFrequency (%) 
90001 4 0.1%
 
90002 4 0.1%
 
90003 5 0.1%
 
90004 5 0.1%
 
90005 4 0.1%
 
ValueCountFrequency (%) 
96150 2 < 0.1%
 
96148 4 0.1%
 
96146 4 0.1%
 
96145 3 < 0.1%
 
96143 4 0.1%
 

Correlations

Missing values

Sample

First rows

AgeAvg_Monthly_GB_DownloadAvg_Monthly_Long_Distance_ChargesChurn_CategoryChurn_LabelChurn_ReasonChurn_ScoreChurn_ValueCityCLTVContractCountCountryCustomer_IDCustomer_StatusDependentsDevice_Protection_PlanGenderIDInternet_ServiceInternet_TypeLat_LongLatitudeLongitudeMarriedMonthly_ChargeMultiple_LinesNumber_of_DependentsNumber_of_ReferralsOfferOnline_BackupOnline_SecurityPaperless_BillingPayment_MethodPhone_ServicePopulationPremium_Tech_SupportQuarterReferred_a_FriendSatisfaction_ScoreSenior_CitizenStateStreaming_MoviesStreaming_MusicStreaming_TVTenure_in_MonthsTotal_ChargesTotal_Extra_Data_ChargesTotal_Long_Distance_ChargesTotal_RefundsTotal_RevenueUnder_30Unlimited_DataZip_Code
07880.00CompetitorYesCompetitor offered more data911Los Angeles5433Month-to-Month1United States8779-QRDMVChurnedNoYesMale21YesDSL34.02381, -118.15658234.023810-118.156582No39.65No00NoneNoNoYesBank WithdrawalNo68701NoQ3No3YesCaliforniaYesNoNo139.65200.000.0059.65NoNo90022
1391842.55NaNNoNaN420Los Angeles4658Two Year1United States4737-AQCPUStayedNoYesMale21YesDSL34.02381, -118.15658234.023810-118.156582Yes72.10Yes05NoneYesYesNoCredit CardYes68701YesQ3Yes3NoCaliforniaNoNoNo725016.6503063.600.008080.25NoYes90022
232267.11NaNNoNaN340Los Angeles3503Month-to-Month1United States5043-TRZWMJoinedNoYesFemale21YesFiber Optic34.02381, -118.15658234.023810-118.156582No75.55No00NoneNoNoNoBank WithdrawalYes68701NoQ3No5NoCaliforniaNoNoNo175.5507.110.0082.66NoYes90022
335250.00NaNNoNaN460Los Angeles5748Two Year1United States8165-CBKXOStayedYesYesMale21YesCable34.02381, -118.15658234.023810-118.156582Yes56.75No34NoneYesNoYesCredit CardNo68701NoQ3Yes3NoCaliforniaYesYesYes663708.4000.000.003708.40NoYes90022
4204236.49NaNNoNaN380Los Angeles5545One Year1United States9979-RGMZTStayedNoNoFemale21YesFiber Optic34.02381, -118.15658234.023810-118.156582No94.05No00Offer EYesNoYesCredit CardYes68701NoQ3No3NoCaliforniaYesYesYes7633.450255.430.00888.88YesYes90022
5741748.85CompetitorYesCompetitor made better offer691Los Angeles5302Month-to-Month1United States7495-OOKFYChurnedYesNoFemale54YesFiber Optic34.044271, -118.18523734.044271-118.185237Yes80.65Yes11Offer EYesNoYesCredit CardYes55668NoQ3Yes3YesCaliforniaNoNoNo8633.300390.800.001024.10NoYes90063
6682122.74NaNNoNaN420Los Angeles5140Two Year1United States4918-FYJNTStayedNoYesFemale54YesFiber Optic34.044271, -118.18523734.044271-118.185237Yes90.45Yes04NoneYesNoNoBank WithdrawalYes55668YesQ3Yes4YesCaliforniaNoNoNo555044.8001250.7012.486283.02NoYes90063
7402413.58DissatisfactionYesService dissatisfaction651Los Angeles5020Month-to-Month1United States3891-PUQODChurnedYesYesFemale54YesDSL34.044271, -118.18523734.044271-118.185237No59.20No30NoneNoNoNoBank WithdrawalYes55668NoQ3No1NoCaliforniaYesYesNo159.20013.580.0072.78NoYes90063
8284143.77NaNNoNaN420Los Angeles5845One Year1United States0052-DCKONStayedNoYesMale54YesFiber Optic34.044271, -118.18523734.044271-118.185237Yes115.80Yes09NoneYesYesNoBank WithdrawalYes55668YesQ3Yes3NoCaliforniaYesYesYes667942.1502888.820.0010830.97YesYes90063
949530.00NaNNoNaN470Los Angeles5498Two Year1United States3704-IEAXFStayedYesNoFemale54YesDSL34.044271, -118.18523734.044271-118.185237Yes53.65No39NoneYesNoNoCredit CardNo55668YesQ3Yes3NoCaliforniaYesYesYes723784.0000.000.003784.00NoYes90063

Last rows

AgeAvg_Monthly_GB_DownloadAvg_Monthly_Long_Distance_ChargesChurn_CategoryChurn_LabelChurn_ReasonChurn_ScoreChurn_ValueCityCLTVContractCountCountryCustomer_IDCustomer_StatusDependentsDevice_Protection_PlanGenderIDInternet_ServiceInternet_TypeLat_LongLatitudeLongitudeMarriedMonthly_ChargeMultiple_LinesNumber_of_DependentsNumber_of_ReferralsOfferOnline_BackupOnline_SecurityPaperless_BillingPayment_MethodPhone_ServicePopulationPremium_Tech_SupportQuarterReferred_a_FriendSatisfaction_ScoreSenior_CitizenStateStreaming_MoviesStreaming_MusicStreaming_TVTenure_in_MonthsTotal_ChargesTotal_Extra_Data_ChargesTotal_Long_Distance_ChargesTotal_RefundsTotal_RevenueUnder_30Unlimited_DataZip_Code
703327011.57NaNNoNaN290Alturas5962Two Year1United States5647-URDKAStayedYesNoMale1632NoNone41.468877, -120.5422941.468877-120.542290Yes19.70No18NoneNoNoNoCredit CardYes5096NoQ3Yes4NoCaliforniaNoNoNo8130.25092.560.0222.81YesNo96101
7034298527.37NaNNoNaN800Topaz2200Month-to-Month1United States9143-CANJFStayedYesNoFemale1659YesDSL38.636052, -119.48916238.636052-119.489162Yes55.15No37NoneNoYesNoBank WithdrawalYes116YesQ3Yes3NoCaliforniaNoNoNo241319.850656.880.01976.73YesYes96133
703533263.09NaNNoNaN210Topaz5619Two Year1United States4973-MGTONStayedNoYesFemale1659YesDSL38.636052, -119.48916238.636052-119.489162Yes84.40No00NoneYesYesYesCredit CardYes116YesQ3No5NoCaliforniaYesYesYes715969.300219.390.06188.69NoYes96133
7036341928.21NaNNoNaN680Topaz4668Two Year1United States5702-KVQRDStayedNoYesMale1659YesDSL38.636052, -119.48916238.636052-119.489162Yes82.55No02Offer ANoYesYesBank WithdrawalYes116YesQ3Yes3NoCaliforniaYesYesYes715832.6502002.910.07835.56NoYes96133
703734274.89NaNNoNaN470Jacumba2711Month-to-Month1United States8148-BPLZQStayedNoNoMale303YesCable32.649787, -116.223732.649787-116.223700No49.80No00NoneYesNoYesBank WithdrawalYes699NoQ3No4NoCaliforniaNoNoNo341734.2070166.260.01970.46NoNo91934
7038215916.06NaNNoNaN620Jacumba4504Month-to-Month1United States9108-EJFJPJoinedNoNoFemale303YesDSL32.649787, -116.223732.649787-116.223700Yes53.55No06Offer EYesYesYesCredit CardYes699NoQ3Yes4NoCaliforniaNoYesNo153.55016.060.069.61YesYes91934
7039362423.13NaNNoNaN260San Diego5416One Year1United States0795-GMVQOStayedNoYesMale357YesFiber Optic32.741859, -117.09035332.741859-117.090353Yes109.90Yes01NoneYesYesNoCredit CardYes73006NoQ3Yes4NoCaliforniaYesYesYes677332.4001549.710.08882.11NoYes92105
7040323023.42NaNNoNaN320San Diego4062Month-to-Month1United States9547-ITEFGStayedYesYesMale357YesFiber Optic32.741859, -117.09035332.741859-117.090353Yes102.60Yes38Offer EYesNoYesCredit CardYes73006NoQ3Yes5NoCaliforniaYesYesYes9897.750210.780.01108.53NoYes92105
7041623037.69NaNNoNaN660Holtville5471Month-to-Month1United States4993-JCRGJStayedNoYesMale404YesFiber Optic32.811001, -115.15286532.811001-115.152865No84.30Yes00NoneNoNoYesCredit CardYes8062YesQ3No5NoCaliforniaNoNoNo262281.600979.940.03261.54NoYes92250
704250031.33NaNNoNaN220Holtville4769Month-to-Month1United States6082-GLJIXStayedNoNoMale404NoNone32.811001, -115.15286532.811001-115.152865No19.25No00Offer DNoNoNoCredit CardYes8062NoQ3No5NoCaliforniaNoNoNo18331.350563.940.0895.29NoNo92250